package com.jackrain.nea.fc.dl.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.HashMap;

/**
 * @author wuwenxue
 * @date 2018/07/02
 **/
@Mapper
public interface ViewDLTranPlanMapper {

    @Select("SELECT PS_C_PRO_ID,PS_C_SPEC1OBJ_ID,PS_C_SPEC2OBJ_ID,ID FROM PS_C_SKU " +
            "WHERE ECODE=#{ecode} AND CP_C_DISTRIB_ID=0 ")
    HashMap selSkuData(String ecode);

    @Select("SELECT ENAME,ECODE FROM PS_C_SPECOBJ WHERE ID=#{ps_c_spec1obj_id}")
    HashMap selSpecobjData(Long ps_c_spec1obj_id);

    @Select("SELECT ECODE,ENAME,IMAGE,PRICELIST,NUMDIM26 FROM PS_C_PRO " +
            "WHERE ID=#{ps_c_pro_id} AND CP_C_DISTRIB_ID=0")
    HashMap selProData(Long ps_c_pro_id);

    @Select("SELECT ECODE,ENAME FROM PS_C_PRODIM_ITEM " +
            "WHERE ID=#{pro_type_depart_id}")
    HashMap selProItemData(Long pro_type_depart_id);

    @Select("SELECT ID FROM CP_C_STOREORG " +
            "WHERE ECODE=#{storeOrgEcode}")
    HashMap selStoreOrgData(String storeOrgEcode);

    @Select("SELECT STORETYPE,ID FROM CP_C_STORE " +
            "WHERE ECODE=#{storeEcode}")
    HashMap selStoreData(String storeEcode);


}
